package com.example.util;

import java.sql.Connection;
import java.sql.DriverManager;

public class DBConnection {
    private String FileName;
    public int DBType;
    private Connection conn;
    private String MySqlDriver;
    private String MySqlURL;
    public DBConnection() {
        conn = null;
    }
    public Connection getConn() {
        DBType = 1;
        switch (DBType){
            case 1:
                return (getConnToMySql());
            default:return null;
        }
    }
    public Connection  getConnToMySql() {
        try {
            MySqlDriver = "com.mysql.cj.jdbc.Driver";
            MySqlURL = "jdbc:mysql://localhost:3306/unit7website" +
                    "?user=root&password=mysql&useUnicode=true" +
                    "&characterEncoding=UTF-8";
            Class.forName(MySqlDriver).newInstance();
            conn = DriverManager.getConnection(MySqlURL);
        }catch (Exception e){
            System.out.println("连不上数据库");
        }
        return conn;
    }
}
